OpenCities Map Help

To Define a Non-Graphical Sub-Feature

  1. Create the table with no geometry column, one ID, and one foreign key.
    CREATE TABLE NO_GRAPHIC
    ​(ID NUMBER PRIMARY KEY,
    LinkedID NUMBER,
    ​Name VARCHAR2(50));
  2. Create the foreign key constraint defining the non-graphical sub-feature.
    ALTER TABLE NO_GRAPHIC
    ​ADD CONSTRAINT NoO_GRAPHIC_CABLEFK
    ​FOREIGN KEY(LinkedID)
    ​REFERENCES CabCABLE)
    ​ON DELETE CASCADE;